/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : 127.0.0.1
 Source Database       : imooc

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : utf-8

 Date: 05/12/2017 14:13:06 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `deepcate`
-- ----------------------------
DROP TABLE IF EXISTS `deepcate`;
CREATE TABLE `deepcate` (
  `id` int(10) NOT NULL COMMENT 'id',
  `pid` int(10) NOT NULL COMMENT '父id',
  `catename` varchar(30) NOT NULL COMMENT '分类',
  `cateorder` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `createtime` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `deepcate`
-- ----------------------------
BEGIN;
INSERT INTO `deepcate` VALUES ('1', '0', '新闻', '0', '0'), ('2', '0', '图片', '0', '0'), ('3', '1', '国内新闻', '0', '0'), ('4', '1', '国际新闻', '0', '0'), ('5', '3', '北京新闻', '0', '0'), ('6', '4', '美国新闻', '0', '0'), ('7', '2', '美女图片', '0', '0'), ('8', '2', '风景图片', '0', '0'), ('9', '7', '日韩明星', '0', '0'), ('10', '9', '日本AV', '0', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
